SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39891 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39891 [ RunTime:0.001430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68039,1013960,995420,365349,661435,651978,205638,331084,199057,201001,278221,115231,57669,759609,955484,215605,347093,110711,243232,828163,596262,228663,314560,869847,763820,15537,32299,315196,464526,528737,269096,865279,426020,454170,1000821,307006,1021816,670542,118767,714730,732818,487782,150941,466915,258563,576270,441610,446352,69919,3413,244617,658850,93718,470310,678582,431184,142556,174230,932091,933528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]