SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 716380 LIMIT 1 [ RunTime:0.004424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 716380 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150024,421562,787321,437759,732701,352175,991691,788349,804148,63865,666155,940980,511080,548235,349143,687612,795862,91429,418087,484556,589999,708924,480928,248749,19507,483244,627265,699562,560427,217835,247034,787446,413137,572528,598081,64351,560060,85150,114354,644865,654183,821907,975151,842916,939524,975464,672235,901013,389319,358958,197074,424827,72291,68242,903172,228670,888335,590351,363407,208199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 716380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 716380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001268s ]