SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343074 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343074 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959355,388850,696526,391991,133336,348867,439747,687233,113768,686823,892856,102454,782020,475964,720047,68137,714703,999105,579624,711529,543464,296143,403510,1036407,888200,567388,888734,306096,172312,166814,497215,1006312,761305,571238,1023400,296103,463772,308948,238371,25187,418,41772,470476,71895,1011864,156214,19927,999416,477466,713502,760159,993608,608203,33710,706182,148296,483234,983769,843356,73026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001756s ]