SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044343 LIMIT 1 [ RunTime:0.001970s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044343 [ RunTime:0.002776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817847,884426,752789,801411,820179,370936,922311,709438,830437,1032534,522038,842291,370770,373098,1020999,115439,646518,101637,200779,355569,666415,850567,245717,232834,224843,157734,296955,251198,686198,767687,84364,28382,158616,484319,387488,118961,676665,530742,399143,708561,419229,396446,141609,224235,293315,164606,589204,662226,291629,1003506,940233,375905,324804,890772,213959,769293,705617,347591,639950,488040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002489s ]