SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426059 LIMIT 1 [ RunTime:0.000640s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426059 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364839,751400,168506,941016,987807,168595,80040,440431,766221,20992,427848,896395,437262,803097,385056,287125,679920,418667,280235,379448,34090,1014768,938551,296151,411473,471684,781631,661176,424885,786473,1041383,244399,309084,451986,758698,768851,386525,248359,834636,115250,144534,640541,712414,70993,874405,15478,182634,524801,583643,138231,608765,818759,665184,514042,918203,943305,412109,485772,5983,116420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]