SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002973s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291054 LIMIT 1 [ RunTime:0.002868s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291054 [ RunTime:0.005258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883544,647692,565885,236996,410990,142496,441453,769544,496640,381545,719802,357411,718447,786022,717536,576387,366950,523216,193676,136139,939722,316123,186501,822282,367356,939806,946866,839743,316437,159747,315472,886083,1043794,162354,611391,475258,1037644,272064,146228,965612,210104,442373,642706,893256,395787,809153,317154,454680,460804,293820,853259,911085,39949,851175,914504,619948,536178,179977,385865,543994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]