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` = 1040997 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040997 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163699,618263,191364,986535,871461,363985,424324,96048,323080,673502,875139,485143,1020567,358041,1035671,539384,46441,972096,256287,257721,242575,696133,676881,907668,207436,37059,229871,628930,862653,12409,673278,816845,962162,588975,165073,695837,134547,541270,115024,374589,200349,462609,387359,332732,227765,819830,1011804,956902,710078,254727,207181,635781,1019666,299781,1038044,537652,1045619,141696,692511,335591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]