SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524584 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524584 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493844,274258,703278,942774,159327,104775,774500,715016,371745,731297,433449,426767,429722,968344,359816,592804,245583,1016000,607729,838516,124502,189003,397810,15252,517050,949517,790311,338766,973140,701538,325529,760486,689102,195060,471143,644439,484002,833908,443921,767075,256286,236854,351277,690534,485344,140119,931811,74034,636474,831104,457237,136702,745129,409301,96583,564536,948548,268819,105613,674203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]