SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803650 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803650 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569874,882131,227704,596481,247168,512260,784249,82092,868783,152096,638350,410339,543496,913848,176772,126619,1002313,1035765,605354,322827,956491,979855,180720,414415,1014161,303531,107825,344578,698077,819417,22491,929399,474727,770669,866812,195997,665348,779403,708901,718359,275653,857964,289155,932730,889169,230968,567713,615595,795599,629073,251596,143967,753533,982246,35834,43961,824489,594667,485020,871555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]