SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492412 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492412 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527893,538902,722489,656401,1013227,9218,415721,116319,381954,329234,979204,547304,1036684,375089,252439,595120,948051,335197,682814,253317,726190,365167,205551,889221,1005222,676215,659387,723493,987206,680120,216449,482722,257471,315403,1011396,252186,696485,991140,69092,681961,643414,587802,195508,726559,134574,49678,1039398,948367,245577,983566,237218,615880,408268,381424,996421,892580,236457,348189,260939,632571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]