SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038542 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038542 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187201,849778,214552,93433,492445,664654,936789,22582,755676,862870,1028764,1042343,614041,975503,967021,59087,1002782,61469,95327,281515,755697,667646,1017602,143330,907384,796957,134041,677347,924841,850272,457441,209064,673826,1043269,722350,244391,688368,1024708,283393,284702,568230,788111,793071,919975,719905,562991,995728,361976,551128,172557,497190,701663,182228,814330,103855,706494,1048496,1021110,374116,863887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]