SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 751023 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 751023 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041476,447661,170994,688039,719985,1028629,327199,106795,363521,253164,306512,559186,263251,442399,770018,410788,511883,90140,534120,388446,780991,496539,334634,251009,63995,416277,1014117,394645,677946,91064,474916,40393,672752,356692,977180,516600,268648,293637,874689,434658,550787,648838,675373,198680,960793,832754,634342,1032360,339834,577053,144422,394258,127098,904955,479554,989112,377701,60302,412404,942974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 751023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 751023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]