SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529263 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529263 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627099,295857,643282,31134,573493,62429,997658,814127,199560,511846,600739,694581,924570,459597,244234,763996,150697,30222,531201,631286,439523,629290,968402,245391,271066,979123,706786,496752,411636,1017849,284636,934602,597427,252110,539314,216816,173309,1009404,748141,1008074,300424,261480,656379,626474,386717,495381,926995,757105,301798,590766,391596,136814,332289,185471,22876,708582,729956,286051,97833,152974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]