SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11917 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11917 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040997,182509,261143,68275,479416,1009667,46866,497139,406383,657459,1006333,405845,659567,159289,888857,266097,944017,38181,818371,792000,969692,197983,874295,1007544,271028,353846,505338,838313,117152,865390,922097,140089,645700,51390,281097,943880,213520,721878,443083,288537,912651,283976,713390,1005537,434665,480623,814547,918618,941307,242324,507893,982710,538745,310839,268882,807946,125541,774196,521413,274742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]