SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260883 LIMIT 1 [ RunTime:0.005637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260883 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032854,523554,452541,145297,519202,376838,160253,127097,464846,265258,719328,135315,54374,641741,227535,758174,411577,105040,758941,376132,705276,829578,210958,763508,384661,41021,481072,566669,423635,495330,854900,887409,469115,555977,559357,362972,429852,654780,745403,123995,639013,653066,768960,540838,421460,86217,793166,350781,800645,180441,310837,683500,372437,483746,648534,819663,29543,223866,529238,179091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]