SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569891 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569891 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138295,652980,607112,1030401,479586,809452,531922,105873,612771,722426,57088,5565,89122,763453,873959,362137,930833,1030797,178044,457268,788321,202884,921159,337433,147101,532443,187400,246508,689933,741510,915408,1035341,332625,418108,379995,201931,856528,253574,703384,132186,263433,828726,868574,241924,488434,814160,822537,711365,1227,586750,535078,963631,83666,751990,527354,378056,754107,880486,39078,817764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]