SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506587 LIMIT 1 [ RunTime:0.000837s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506587 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310250,835531,19661,444039,239001,945930,132545,535531,205918,1045195,610425,451939,257202,200031,454190,58006,17649,819137,817773,488550,733718,868205,185070,593922,258641,383919,209472,186680,482737,586714,532400,903100,755597,1000521,110373,275736,341932,427353,501448,861117,553807,679260,128769,834093,686132,670887,279749,608216,68360,69921,240245,158879,193455,636343,65387,1008127,197130,327306,219036,315439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506587 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506587 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]