SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535424 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535424 [ RunTime:0.002652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478593,731204,796656,710368,525325,807456,405589,226985,120729,42240,38734,823581,22865,1025937,91371,381233,826118,703564,215022,43295,947913,501066,173645,818923,609634,305160,480172,832576,213493,121893,551705,360539,124562,175015,158036,537893,455625,522126,307257,994207,139400,384589,979788,148711,173418,15653,837631,669603,1012564,387067,973956,930342,621917,348445,147779,225999,768299,299060,639890,921878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001350s ]