SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542513 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542513 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143377,78854,572555,683442,449067,575054,748698,863774,855022,575899,893055,996655,875804,1003363,723425,65998,491909,443761,455050,749816,131588,474896,15803,732405,326390,118260,672867,702886,748547,798943,797660,966664,527782,948587,707566,336637,57086,1027456,621350,667924,586329,44419,408220,784248,941110,246315,521719,610021,590144,588716,42499,390508,1028165,235001,564303,286743,944905,336590,44179,48873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]