SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022850 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022850 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509814,645315,61431,994284,402104,509604,727741,911103,900012,87424,885540,908642,585301,995072,808395,645999,570343,347892,460411,390173,10838,995595,1003870,333503,67601,408316,67979,846167,1014228,399041,984801,388249,548763,1027425,906615,986079,417232,82179,970280,82712,214889,618245,962588,914461,512226,854667,444170,603509,532004,116216,547275,364794,29382,540006,223208,7774,126788,1016466,727742,189658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]