SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267176 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267176 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39172,304117,997671,41798,54120,707360,147857,25709,697055,470679,504130,196213,505594,903408,718076,985181,134882,91887,710454,1020900,958225,295657,754539,626204,796903,73640,279016,432680,982093,786606,317963,537596,150695,201924,538949,668927,508187,963147,387097,68812,252475,809300,462145,539285,324150,1012967,337160,1010474,536336,512699,484914,383256,926349,94641,347513,681925,928577,477605,806107,643269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]