SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440047 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440047 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900186,450025,857679,300753,147372,869236,847826,615679,773732,885853,265085,817648,193628,177169,29689,911811,931972,754576,385752,513875,588266,875933,681545,175658,685770,760971,768732,459743,534061,739170,940218,481574,84728,172937,133379,651987,505402,543670,725384,174185,227119,368911,317746,39686,332539,220605,438994,680042,900618,669022,871913,309076,635891,625316,12318,21918,794815,985487,24073,281791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]