SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001879s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47390 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47390 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425380,874643,924608,411706,534549,431194,780668,642872,250816,424663,172092,374030,552123,936560,572526,1014224,637800,829571,110007,730059,38562,1027509,1014785,380726,895951,305532,113217,104621,1027201,938539,858182,385236,64741,770190,809079,176614,142944,1027398,94846,733293,543974,660300,439296,196796,861548,333055,820380,1035578,769629,978823,742221,877151,239293,838424,388570,687485,1023148,264689,625370,559173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001594s ]