SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407551 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407551 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365090,538786,643029,134145,525225,89096,744895,424381,196552,157057,732323,353450,393424,644473,729776,67089,137818,275749,830790,1043269,848283,354274,121367,251545,438962,326381,377677,592411,445923,648711,775483,1002216,615896,773060,262237,984238,771897,961920,70282,792408,734921,252442,815853,164073,962583,189789,114386,148457,461211,572704,693090,46567,1040534,310928,325011,342364,195910,464965,657784,1019894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]