SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481413 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481413 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405436,690239,226394,822986,614823,843634,765181,1017704,395550,576727,210395,111426,376682,154952,564495,210334,741325,375639,889739,260685,895184,1004610,503112,545203,509219,68700,1043081,290247,417735,794758,505750,65912,587610,767930,223954,427172,373848,827634,507224,1033461,1001138,612418,412128,157157,242374,829482,1024117,369269,671026,859158,636143,571068,624506,166193,208115,827379,201368,169427,854356,700715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]