SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406670 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406670 [ RunTime:0.010012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202381,1017195,140808,556966,873627,197826,180078,1038198,169934,40955,31730,643588,495345,222637,823320,106152,405826,158447,815373,758330,107775,750907,538792,763031,780016,1045181,629932,456176,614002,763683,443687,255905,182660,712667,440213,912865,700039,872047,547896,189388,166262,540386,937110,782980,464727,647267,269402,691031,1045269,2920,648015,1025590,606057,36884,689905,762363,205931,977892,510258,922635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]