SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421968 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421968 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031347,730232,700642,215971,447346,1030597,194814,354144,111122,367440,1036959,561818,996251,333568,703370,515151,809808,164052,127438,213543,536699,188923,271824,195961,268505,748594,606560,334240,942386,183739,780711,688751,980387,459670,751793,116652,507474,440712,1036,442835,311227,910969,393067,1697,376148,26685,337576,268826,22351,858321,747335,120027,269394,389950,609092,917502,527932,798219,306264,859823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000747s ]