SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023133 LIMIT 1 [ RunTime:0.005141s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023133 [ RunTime:0.002739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103344,997418,38410,437787,102472,881185,973656,1046287,954599,930688,484432,711539,445599,509849,33742,1000075,611713,901774,485245,163558,329642,812794,457069,314087,930566,1010,396987,454705,844217,342150,1012281,12411,202235,257161,309453,321017,554839,493738,863935,774693,252858,410626,179490,464518,911874,382570,823937,307958,826065,93602,787754,775741,987321,134066,980532,483539,64848,209680,844270,490747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]