SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421903 LIMIT 1 [ RunTime:0.001370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421903 [ RunTime:0.003046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771419,678400,1039090,590293,882623,283752,239709,142673,8433,208255,745586,191390,104228,242041,850116,627508,486149,873126,1016008,254100,264422,526082,759054,170636,53646,147784,610757,411153,746227,935921,419029,188261,607456,732657,390380,769705,794842,703209,559034,342790,183735,715592,972128,818083,787577,814033,790774,346717,957955,779424,345817,791695,513380,227369,379313,184505,821381,970353,413939,617993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002109s ]