SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530416 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530416 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180420,473773,447241,433935,781334,406496,104713,739170,374006,786282,243444,911279,99490,807993,549434,1021132,759020,37977,508159,114549,183878,293800,633530,1010474,169490,562849,747819,905356,494459,30289,68299,10351,623064,281705,685914,499017,773387,142073,939688,637337,105882,645907,1046415,212662,562586,86128,786862,726600,290736,490797,55186,233825,391308,193543,295420,1033032,842222,706059,46992,920029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]