SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510801 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510801 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48805,852513,956410,898434,38857,112951,967188,80085,279818,467521,909518,178400,368852,346527,508644,944355,53875,574250,337047,1025937,995245,897085,60869,560950,877920,139987,626692,898396,354536,718153,489846,466070,51347,629309,834414,515270,235082,95002,522732,635616,872632,617593,203834,901643,637047,831150,994693,914045,939243,793819,676650,946905,998525,386416,73043,334739,416398,201171,250260,799786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]