SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50372 LIMIT 1 [ RunTime:0.000995s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50372 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550636,602326,166465,742927,232578,476773,70213,1001625,428624,829167,336646,473922,967855,709388,432494,936453,891991,638569,423605,194283,231233,974418,116082,394810,77987,1017788,221026,145605,808172,714729,344574,941863,49524,584055,521570,752382,610197,606767,10816,817328,773120,1017089,835675,618521,1007559,303267,687642,318261,111503,1004102,963167,713015,405431,575443,666058,205064,541764,803270,247203,847152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50372 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50372 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000342s ]