SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447150 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447150 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151920,179836,104151,107358,464791,254961,759448,581053,65023,513474,23026,971026,508020,66050,954100,1041939,379189,187588,957520,224477,355449,74953,259669,506414,863106,658964,996018,372551,36734,574976,872786,1041062,791906,41658,207678,317255,561325,921593,561092,42531,1012575,256235,265219,100112,620212,785399,317500,1018730,375340,204580,533564,456409,133423,765248,610956,685138,638629,158258,770091,61773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]