SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391042 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391042 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221480,435810,349353,906300,265519,152522,479995,415853,485025,609032,527550,222410,763725,802374,564182,240387,1028752,11924,189317,669060,304030,809198,330973,2386,130749,984638,869811,372725,407425,829742,815658,196914,1010560,519264,787360,498204,314879,1462,840953,702907,367586,301130,740551,630238,527679,300771,567549,484222,888839,44022,822521,116503,237750,645349,729485,646275,569351,953716,18674,452180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001347s ]