SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437674 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437674 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217032,687871,424916,828617,301104,185022,36727,413753,508015,2824,1037161,551004,652857,803575,523059,246008,829299,351424,36448,629679,1030555,75109,696637,754028,920327,87787,290728,846671,247456,925673,864135,113140,385709,260099,414234,634825,752561,966900,326803,709789,348973,749212,483845,53726,1021369,750884,368628,184374,168590,663994,573407,865850,837774,1041916,673010,946550,215446,155922,698861,372387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001265s ]