SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423670 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423670 [ RunTime:0.003409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618561,714878,119392,727316,127498,173462,464760,193311,356968,67942,1039391,342120,554010,612835,317352,159898,944522,454173,140734,1028552,876232,450243,899966,660116,648529,967863,470290,111099,585031,1043337,365019,917914,670398,890727,265181,883439,771581,154507,780255,690720,996023,866718,902908,645755,897913,151915,210766,505202,376019,549699,123311,540087,753010,876625,741622,1007197,828997,223317,866750,608972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]