SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101317 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101317 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580869,987569,634914,289049,905620,809790,500022,846392,94913,135417,187628,443930,212014,524349,660335,250871,387411,243975,296177,321748,622986,248794,833966,178733,978737,1024742,527760,189367,856966,477539,1013289,451624,559637,427211,835489,268760,428387,236190,596722,198675,622830,596717,59168,537271,270045,607636,532295,351377,99397,475317,244193,435010,852463,300936,453433,82733,674347,742643,823863,687753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]