SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981927 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981927 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391116,393250,317625,904833,193642,266736,242399,238929,188048,343839,107984,277690,228217,921124,213,467414,565785,203987,457287,429201,842594,898597,783652,96053,606560,468495,198737,699728,655623,261962,66510,433613,315017,131320,139899,542568,1011733,730447,136177,555319,616076,551300,931270,228362,919912,888621,757554,929341,387043,934111,210568,103571,488146,986879,521807,439508,257897,676563,296267,75737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]