SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 131191 LIMIT 1 [ RunTime:0.000837s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 131191 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535548,952023,952113,468671,114198,943076,277702,582880,166116,294414,994894,769462,188863,695954,471488,626354,639352,12373,618743,777615,543016,121044,843180,149706,811745,70616,206944,244752,428108,325571,863633,940952,414256,354808,520057,976781,1015896,232688,907713,619423,244347,354467,1031829,380528,77255,789269,261423,216392,211930,65050,564271,360549,484590,187509,708562,733459,149600,895544,698716,674792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 131191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 131191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]