SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525654 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525654 [ RunTime:0.004045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181574,153728,575059,627078,524258,54090,102551,823272,626697,900634,778741,335531,982170,903001,28084,1035982,694913,974844,836216,234722,994571,196654,66742,214763,1025477,900110,657608,561265,166123,254317,310847,255253,732074,183793,710520,142574,1034306,887438,577455,489873,461370,34298,1005223,234644,412661,549657,588774,197050,564126,251167,293641,868954,98431,1039141,557845,716738,177545,1023405,11319,1021373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001594s ]