SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536364 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536364 [ RunTime:0.004600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003590,958176,101964,361438,480916,796666,801794,770133,106795,635817,390422,682034,351797,440115,1018016,1023659,154065,907889,996889,998176,835020,650524,38438,362839,339068,479386,656163,334950,731182,62904,683578,504406,693044,755610,929075,982323,130713,839485,690398,904198,655220,1043446,648924,436443,695933,45848,896166,486451,106355,463267,1031133,388545,101409,393501,504202,917171,379467,302636,181729,445472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001137s ]