SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50600 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50600 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038579,474233,712250,649145,32292,475588,580507,632377,853040,404299,248420,772784,244788,643345,316143,924460,20229,807541,944843,773342,244062,575642,708428,313754,508007,295559,694146,392524,837723,949893,54404,540302,504436,50862,575069,582193,550178,230556,154925,506150,349939,967654,981597,155588,993686,411266,148658,343359,749156,46956,994708,755193,455741,203462,703376,237659,798678,41546,533006,833731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]