SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531257 LIMIT 1 [ RunTime:0.001106s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531257 [ RunTime:0.005315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282639,46662,343163,415577,417794,899129,926966,861283,933720,446705,373679,500106,954022,891136,452049,13074,284395,982323,956353,849326,807887,137675,770155,141991,331588,481473,817457,420450,809015,33803,88594,454513,175112,233155,523607,762570,423608,845766,22980,595772,843715,58433,514975,287482,319362,913101,149974,613761,311246,574512,224820,468391,577735,67997,586508,1009688,291820,565680,145940,381060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003307s ]