SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027370 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027370 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595339,621151,492742,508785,455024,20775,264890,715553,123755,754435,537525,137924,675854,436242,641295,571145,92851,592997,335115,456392,916551,258089,1030782,153568,24476,303838,742596,812490,905868,222146,1025212,51184,752002,288459,775082,686952,785854,76506,568127,523753,535933,1015101,575006,512357,886833,208738,583954,221177,36613,300776,71629,272512,222313,1027519,144876,586935,106724,582550,1041516,367209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]