SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416918 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416918 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86298,749739,576270,644345,553909,843144,786402,317538,228934,112155,308701,461547,82022,530163,1019507,212050,475725,910066,550634,694534,1008702,25483,607739,129602,16346,1022508,934458,879702,792600,734260,352554,864058,445208,208683,526596,1044365,763358,9657,25860,464583,826459,713196,530869,294246,222475,521729,290566,65644,543045,1041960,503639,582507,410981,103601,104885,502445,884424,970983,466301,444253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]