SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280236 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280236 [ RunTime:0.002770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529408,257975,398245,470494,655328,252602,970427,271555,913043,346057,569903,933541,989481,856735,951021,674491,610592,524890,61138,242575,396001,957513,605017,602106,121037,890860,517275,288378,197741,372320,388965,507142,419217,215692,359444,505869,127140,710764,485876,67195,123942,201373,2827,932430,311549,621065,753084,670076,825091,523907,39323,51551,18396,131887,130899,905034,211177,572661,1028814,40212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]