SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021287 LIMIT 1 [ RunTime:0.001127s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021287 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699168,225002,792442,766050,703090,192193,858707,441016,234543,630108,185989,463651,758785,1034966,403366,304679,503826,1046939,355199,505249,685743,619012,145371,889547,157544,853410,934158,63941,56069,357533,643387,547929,762821,651613,207072,760079,759312,391813,343090,412912,483951,1015920,723747,231806,602404,726657,881432,997292,935340,296427,241033,290535,600317,356841,206293,408761,333704,335679,645370,112762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]