SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287299 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287299 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780598,312558,1007418,703852,682201,946489,987824,240021,685718,452226,708912,100606,1039297,505043,903192,304998,177440,543707,1013872,817120,68393,376806,180450,825303,372289,273850,697067,628694,399992,561582,337026,339118,415135,680254,451069,599677,622296,737454,511090,585858,276111,1022848,62749,426684,443543,312687,213017,370319,156011,171638,851187,339408,965374,913500,589856,135151,609588,2594,497186,808741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001362s ]