SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436872 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436872 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925101,346059,581303,531688,991772,412739,218227,282247,634800,603783,219589,150128,408437,826910,302637,409101,699730,395185,515243,10708,865889,833698,655867,479498,666104,569833,807931,990396,872821,578533,522854,774344,735816,728736,960349,741275,432332,658796,391115,886439,85455,30059,569095,285629,890373,333210,945647,815077,734612,658884,265374,728386,1031545,146154,316425,255779,973311,836003,221322,281833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003183s ]