SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194017 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194017 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686411,294305,173034,776947,635538,916969,753876,1040821,843662,499711,695883,158173,593109,694792,601928,291398,849349,383281,1039122,1030043,63463,162952,580093,224634,938448,385807,971502,564516,186521,825898,761316,52284,473416,117147,932829,982003,742601,770564,348720,458506,733075,16130,495286,830134,660670,477504,387751,120382,682484,224158,511552,79288,472812,721342,608493,69418,515395,365874,810356,397820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001681s ]