SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190514 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190514 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432309,357789,924316,776640,582760,43480,559989,294092,182042,401137,804213,470761,454387,303837,211634,300926,289428,549971,503554,473570,935839,854232,261845,131115,270074,115097,567306,937383,265070,932318,907669,313666,6801,1031465,300106,351550,182039,109320,531331,1031289,106738,373322,113716,861124,330397,144146,354332,874673,625950,370057,138995,323175,872988,124890,279630,927255,399433,478740,308951,442691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]