SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001718 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001718 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816184,786259,157174,72525,385336,1003548,601446,941961,578782,501792,1040785,668999,890003,833744,69496,198873,1032466,879346,55821,202035,5168,100170,630537,601877,980236,464920,198893,840117,866621,937869,227504,803203,618037,975125,132164,778579,809141,203379,358660,410475,247311,886470,956702,883569,975203,448618,335775,193935,741109,694417,721083,291996,299075,779242,541731,834185,675993,787090,148100,860599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]