SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310920 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310920 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548626,287093,121190,672870,379058,959220,364544,653208,279764,104090,363327,695628,477626,640331,41364,599322,221600,624585,130487,372388,850079,526247,989611,891579,708759,1004520,833707,286267,641648,446080,194586,373655,347578,1041685,244017,421916,602779,356449,65563,899995,892596,614790,715362,179679,391688,395412,942545,621804,1024009,456380,908656,893609,712171,259153,833571,134422,80147,1024763,770739,774644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]