SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403540 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403540 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919526,980006,773259,129206,725323,494294,237720,957741,712292,483302,353476,681571,985610,450371,571429,622508,875384,651036,148224,1034466,435065,1011717,813019,423829,412967,798478,61358,5157,1038043,177444,249811,893038,694790,404769,803228,14173,297701,809250,99185,510542,322622,144739,752867,111781,412743,34427,842768,725552,517766,112770,778359,597056,777335,185225,891030,419270,960345,432596,605989,276400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]