SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402004 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402004 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575406,890963,200118,51694,646897,171343,839544,435419,8144,115892,753452,974811,695789,721321,1015221,786174,146994,38201,955640,861358,813982,350292,126399,1030758,251794,449350,506877,830972,822613,56098,863167,988090,285084,300115,471541,155584,133180,165670,285041,491346,395239,971540,330351,632417,102649,80070,821422,674724,651949,636485,379774,967083,859398,555903,738795,118453,863997,183534,702830,528066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]