SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1840 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1840 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759646,242991,775866,400831,775157,1029294,83057,618901,542162,399154,108290,829544,688766,367126,382084,474330,254596,773736,790079,505790,925184,468950,949445,113145,880710,1007317,93002,194364,1033355,434878,535850,991481,372911,887555,474966,943412,561533,716391,77111,72072,296569,1008728,860876,178194,74727,918877,316107,489327,297270,698318,15474,907411,142574,561829,733984,375539,310076,883879,36172,399962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]