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` = 53428 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53428 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822010,364497,277941,254539,689575,234157,1046205,236322,741907,818884,608514,4299,1040929,588819,635948,106141,532894,242768,863974,399339,552017,850717,149840,549183,671065,320925,887411,280771,55526,768444,256744,886036,661616,870302,769276,804391,876963,1002118,651383,66553,945926,1007942,758857,208660,144449,232347,869891,1022208,449213,23165,976857,81196,620444,62380,558790,1027538,430806,419126,868776,873923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]