SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001917 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001917 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119611,115173,312130,523573,29734,97888,805461,775968,226745,631107,404615,720739,844535,482685,428046,407690,204806,484267,191464,264304,779214,380987,34779,1041851,714809,449716,965957,51998,38199,737218,624551,155610,281963,236401,961702,899245,481535,746892,339571,847403,726183,935527,881668,229211,872521,178183,865488,128092,157992,409129,957509,398502,752911,823561,812571,804807,874226,107294,201319,339812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]