SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154203 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154203 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556327,785351,866768,409870,566685,62593,1022728,502316,569116,736193,68802,106822,505912,822654,644600,944479,265060,302989,275087,852652,303451,709349,748581,588097,635599,20630,362961,753826,963413,460199,174106,1033931,461122,297906,624990,171604,516103,258362,209956,319824,363014,308924,131550,867773,905428,116926,948241,227631,663568,59365,23808,989519,853,634791,692287,49420,255727,930348,308896,861814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]